package educationaladministrationsystem.CSM.Mapper.StudentAndTeacher.Student;

import educationaladministrationsystem.Class.Student;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface StudentPersonDataMapper {
    @Select("select * from student where id=#{id}")
    Student getInformation(Integer id);

    @Select("select name from faculties where id=#{id}")
    String getFacultiesNameByFacultiesId(String id);

    @Select("select name from majorprogram where id=#{id}")
    String getProfessionNameByProfessionId(String id);
}
